const main = {
  add: `INSERT INTO Resume
    (id, fullName, gender, birthday, home, city, salary, tel, email, emergeName, emergeTel, educationHistory, workHistory, projectHistory, awardHistory, selfEvaluate) VALUES
    (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,
  update: `UPDATE Resume SET
    fullName = ?,
    gender = ?,
    birthday = ?,
    home = ?,
    city = ?,
    salary = ?,
    tel = ?,
    email = ?,
    emergeName = ?,
    emergeTel = ?,
    educationHistory = ?,
    workHistory = ?,
    projectHistory = ?,
    awardHistory = ?,
    selfEvaluate = ?
    WHERE id = ?`,
  select: `SELECT * FROM Resume WHERE id = ?`
};

module.exports = main;